
# -*- coding: utf-8 -*-
'''
author:Cooper
date:2012.5.14
update:2012-05-14 17:34
desc:
'''
table_mapping={
    'AfterSale':'after_sale_id,after_sale_name,after_sale_path',
    'Brand':'vid,name,pid,prop_name',
    'Feature':'cid,attr_key,attr_value',
    'Item':'detail_url,num_iid,title,nick,type,desc,skus,props_name,created,promoted_service,is_lightning_consignment,is_fenxiao,auction_point,property_alias,volume,template_id,after_sale_id,is_xinpin,sub_stock,inner_shop_auction_template_id,outer_shop_auction_template_id,cid,seller_cids,props,input_pids,input_str,pic_url,num,valid_thru,list_time,delist_time,stuff_status,location,price,post_fee,express_fee,ems_fee,has_discount,freight_payer,has_invoice,has_warranty,has_showcase,modified,increment,approve_status,postage_id,product_id,item_imgs,prop_imgs,outer_id,is_virtual,is_taobao,is_ex,is_timing,videos,is_3D,score,one_station,second_kill,auto_fill,violation,is_prepay,ww_status,wap_desc,wap_detail_url,cod_postage_id,sell_promise',
    'ItemCat':'features,modified_type,modified_time,cid,parent_cid,name,is_parent,status,sort_order',
    'ItemCategory':'category_id,count',
    'ItemImg':'id,url,position,created',
    'ItemProp':'is_input_prop,type,modified_time,modified_type,pid,parent_pid,parent_vid,name,is_key_prop,is_sale_prop,is_color_prop,is_enum_prop,is_item_prop,must,multi,prop_values,status,sort_order,child_template,is_allow_alias',
    'ItemTemplate':'template_id,template_name,shop_type',
    'Location':'num_iid,uid,zip,address,city,state,country,district',
    'Order':'oid,status,iid,title,price,num_iid,item_meal_id,sku_id,num,outer_sku_id,total_fee,payment,discount_fee,adjust_fee,modified,sku_properties_name,refund_id,is_oversold,is_service_order,item_meal_name,pic_path,seller_nick,buyer_nick,refund_status,outer_iid,snapshot_url,snapshot,timeout_action_time,buyer_rate,seller_rate,seller_type,cid',
    'Product':'product_id,outer_id,created,tsc,cid,cat_name,props,props_str,binds_str,sale_props_str,collect_num,name,binds,sale_props,price,desc,pic_url,modified,product_imgs,product_prop_imgs,status,level,pic_path,vertical_market,customer_props,property_alias',
    'ProductImg':'id,product_id,url,position,created,modified',
    'ProductPropImg':'id,product_id,props,url,position,created,modified',
    'PromotionDetail':'id,promotion_name,discount_fee,gift_item_name,gift_item_id,gift_item_num,promotion_desc,promotion_id',
    'PropImg':'id,url,properties,position,created',
    'PropValue':'modified_time,modified_type,cid,pid,prop_name,vid,name,name_alias,is_parent,status,sort_order',
    'SellerAuthorize':'sid,xinpin_item_cats,item_cats,brands',
    'SellerCat':'type,cid,parent_cid,name,pic_url,sort_order,created,modified',
    'Shop':'sid,cid,nick,title,desc,bulletin,pic_path,created,modified,shop_score,remain_count,all_count,used_count',
    'ShopCat':'cid,parent_cid,name,is_parent',
    'ShopScore':'sid,item_score,service_score,delivery_score',
    'Sku':'properties_name,sku_id,iid,num_iid,properties,quantity,price,outer_id,created,modified,status',
    'Trade':'tid,num,num_iid,status,title,type,price,seller_cod_fee,discount_fee,point_fee,has_post_fee,total_fee,is_lgtype,is_brand_sale,is_force_wlb,created,pay_time,modified,end_time,buyer_message,alipay_id,alipay_no,alipay_url,buyer_memo,buyer_flag,seller_memo,seller_flag,invoice_name,buyer_nick,buyer_area,buyer_email,has_yfx,yfx_fee,yfx_id,has_buyer_message,shipping_type,buyer_cod_fee,express_agency_fee,adjust_fee,buyer_obtain_point_fee,cod_fee,trade_from,alipay_warn_msg,cod_status,can_rate,service_orders,commission_fee,trade_memo,seller_nick,iid,pic_path,payment,snapshot_url,snapshot,seller_rate,buyer_rate,real_point_fee,post_fee,buyer_alipay_no,receiver_name,receiver_state,receiver_city,receiver_district,receiver_address,receiver_zip,receiver_mobile,receiver_phone,consign_time,seller_alipay_no,seller_mobile,seller_phone,seller_name,seller_email,available_confirm_fee,received_payment,timeout_action_time,is_3D,orders,promotion,promotion_details',
    'TradeRate':'valid_score,tid,oid,role,nick,result,created,rated_nick,item_title,item_price,content,reply',
    'User':'user_id,uid,nick,sex,buyer_credit,seller_credit,location,created,last_visit,birthday,type,has_more_pic,item_img_num,item_img_size,prop_img_num,prop_img_size,auto_repost,promoted_type,status,alipay_bind,consumer_protection,alipay_account,alipay_no,avatar,liangpin,sign_food_seller_promise,has_shop,is_lightning_consignment,has_sub_stock,is_golden_seller,vip_info,email,magazine_subscribe,vertical_market,online_gaming',
    'UserCredit':'type,uid,level,score,total_num,good_num',
    'Video':'id,video_id,url,created,modified,iid,num_iid'
}
